Re: no self-joins in views? - works now! - Mailing list pgsql-general

From Christoph Pingel
Subject Re: no self-joins in views? - works now!
Date
Msg-id a06100500be3183b6ad47@[62.224.56.43]
Whole thread Raw
In response to Re: no self-joins in views?  (Christoph Pingel <ch.pingel@web.de>)
List pgsql-general
>>You've got two columns that the system wants to call "obj_id" here.
>>Try something like
>>   SELECT s.obj_id AS s_obj_id, ...
>
>That would have been elegant, but returns a 'syntax error at or near
>"s_obj_id"'. Hm...

Was just some minor syntax error. Works now - this is exactly what I wanted.

Thanks!

regards,
Christoph




pgsql-general by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Profiling ERROR Conditions
Next
From: Michael Fuhr
Date:
Subject: Re: Python Interface